I typed "/usr/local/pgsql/bin/psql -h localhost" and
"/usr/local/pgsql/bin/psql -h 127.0.0.1" and they both returned the
same (odd) message:
psql: FATAL 1: database "postgres" does not exist in the system catalog
I'm connecting through JDBC using 7.1.3 on Darwin (Mac) OS 10.1.
Stefan Huber suggested that I tell JDBC to connect through the
"lo-network" device so that the 127.0.0.1 line in pg_hba.conf works.
thanks for thinking about this problem,
Russ
>Russ McBride <Russ@psyex.com> writes:
> > Thanks for the troubleshooting idea Nick. I can ping localhost which
> > does show up as 127.0.0.1. The error message I get is:
> > No entry in pg_hba.conf_file for 169.245.10.10 [or whatever ip
> > address I happen to be using at the time] for user: postgres
> > database: testdb
>
>Hmph. How are you connecting exactly? Do "psql -h localhost" and
>"psql -h 127.0.0.1" produce different results? What do you have in
>/etc/hosts and /etc/resolv.conf?
>
> regards, tom lane